All Questions
13 questions
21votes
5answers
4kviews
How manage inventory discrepancies due to measurement errors in warehouse management systems
I'm developing an enterprise-grade warehouse management application for a chemistry laboratory. A critical feature involves mixing multiple stock solutions to create new solutions based on predefined ...
- 321
-2votes
2answers
232views
How can we implement an incremental naming system?
Just like how Mac or Windows gives incremental names to new folders, how can we implement such a system in a database? Let's say I have currently 3 folders (default names) i.e., "untitled folder&...
user16595023
1vote
0answers
151views
How to store relational data belonging to different client customers?
My users will be businesses with a small number of accounts each: e.g. Business #1 with 3 users, Business #2 with 5 users, etc. I am trying to determine the best way to organise the relation (on ...
- 111
2votes
4answers
330views
What is the name of DB design pattern which support only soft-deletes and soft-updates?
I heard that there is some DB design in relational databases where updating a record will create a new record with different timestamp or status. Also, deletion will be soft-delete (it updates the ...
- 129
1vote
0answers
465views
Strategies for dealing with Stale data and Fetching
I'm working with firestore and have encountered several situations where a document will contain stale data which is a duplicate of the source of truth located elsewhere in the database. For ...
- 161
1vote
0answers
546views
Polling Postgres DB architecture
We are using Spring Integration DB polling which polls a table every second and executes some logic based on result. My questions are: What are some good practices we can implement to account for DB ...
- 111
-1votes
2answers
86views
Should the TotalGrandPrice be property or Order or Invoice
I'm developing a shop. I'm trying to figure out: where should "total_grand_price" belong to? "total_grand_price" = price of all order items - discount + shipping + taxex +- etc.... Should ...
- 11
5votes
2answers
4kviews
Storing Local Filesystem Paths in Database
I'm developing a webapp where I have sets of data stored locally on my computer and I run a tool which transforms the data and uploads it to my webapp. However, I need to be able to rerun the tool on ...
- 159
1vote
3answers
204views
Is there a design pattern which describes separated join-only views and format-only views
When I'm building views in SQL, I tend to do one of the following: Views that contain logic and criteria for selecting and joining records. I.e. "what records am I interested in and how do they fit ...
- 401
6votes
4answers
706views
Is it too verbose to always have 'modified' time stamps on all entities within a database?
The question can be summarized as: In a database (regardless of type), would it be considered a good practice to always include updated, created (and possibly deleted) properties, for all entities, ...
- 768
0votes
2answers
335views
Dealing with several custom getters
I have a data structure with data units containing different types of data. I've wrapped the data in "Field" objects so that each field is able to independently parse user input in a desired way. ...
- 131
-2votes
1answer
561views
Should We Use Surrogate Primary Keys for Every Table? [duplicate]
We are developing a data model for a marketing database that will import transaction, customer, inventory, etc. files and the directive is ONE process that works for every client. We have been told ...
- 105
2votes
3answers
3kviews
Using a database for each module in a system [duplicate]
I was reading this question: I was trying to standardize and modularize some functions (Email Management Module, CMS Module & etc) by implementing a 3-tier architecture concept where each ...
- 4,449
